/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 510

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 52 45 53 |CHILD UP|DATE RES|
|00000010| 54 52 49 43 54 00 20 20 | 2f 2a 20 45 52 77 69 6e |TRICT.  |/* ERwin|
|00000020| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00000030| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00000040| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00000050| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00000060| 55 50 44 41 54 45 20 52 | 45 53 54 52 49 43 54 20 |UPDATE R|ESTRICT |
|00000070| 2a 2f 0d 0a 20 20 73 65 | 6c 65 63 74 20 63 6f 75 |*/..  se|lect cou|
|00000080| 6e 74 28 2a 29 20 69 6e | 74 6f 20 6e 75 6d 72 6f |nt(*) in|to numro|
|00000090| 77 73 0d 0a 20 20 20 20 | 66 72 6f 6d 20 25 50 61 |ws..    |from %Pa|
|000000a0| 72 65 6e 74 0d 0a 20 20 | 20 20 77 68 65 72 65 0d |rent..  |  where.|
|000000b0| 0a 20 20 20 20 20 20 2f | 2a 20 25 25 4a 6f 69 6e |.      /|* %%Join|
|000000c0| 46 4b 50 4b 28 3a 25 25 | 4e 65 77 2c 25 50 61 72 |FKPK(:%%|New,%Par|
|000000d0| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|000000e0| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 25 4a 6f 69 |) */..  |    %Joi|
|000000f0| 6e 46 4b 50 4b 28 3a 25 | 4e 65 77 2c 25 50 61 72 |nFKPK(:%|New,%Par|
|00000100| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|00000110| 29 3b 0d 0a 20 20 69 66 | 20 28 0d 0a 20 20 20 20 |);..  if| (..    |
|00000120| 2f 2a 20 25 25 4e 6f 74 | 6e 75 6c 6c 46 4b 28 3a |/* %%Not|nullFK(:|
|00000130| 25 25 4e 65 77 2c 22 20 | 69 73 20 6e 6f 74 20 6e |%%New," |is not n|
|00000140| 75 6c 6c 20 61 6e 64 22 | 29 20 2a 2f 0d 0a 20 20 |ull and"|) */..  |
|00000150| 20 20 25 4e 6f 74 6e 75 | 6c 6c 46 4b 28 3a 25 4e |  %Notnu|llFK(:%N|
|00000160| 65 77 2c 22 20 69 73 20 | 6e 6f 74 20 6e 75 6c 6c |ew," is |not null|
|00000170| 20 61 6e 64 22 29 0d 0a | 20 20 20 20 6e 75 6d 72 | and")..|    numr|
|00000180| 6f 77 73 20 3d 20 30 0d | 0a 20 20 29 0d 0a 20 20 |ows = 0.|.  )..  |
|00000190| 74 68 65 6e 0d 0a 20 20 | 20 20 72 61 69 73 65 5f |then..  |  raise_|
|000001a0| 61 70 70 6c 69 63 61 74 | 69 6f 6e 5f 65 72 72 6f |applicat|ion_erro|
|000001b0| 72 28 0d 0a 20 20 20 20 | 20 20 2d 32 30 30 30 37 |r(..    |  -20007|
|000001c0| 2c 0d 0a 20 20 20 20 20 | 20 27 43 61 6e 6e 6f 74 |,..     | 'Cannot|
|000001d0| 20 55 50 44 41 54 45 20 | 22 25 43 68 69 6c 64 22 | UPDATE |"%Child"|
|000001e0| 20 62 65 63 61 75 73 65 | 20 22 25 50 61 72 65 6e | because| "%Paren|
|000001f0| 74 22 20 64 6f 65 73 20 | 6e 6f 74 20 65 78 69 73 |t" does |not exis|
|00000200| 74 2e 27 0d 0a 20 20 20 | 20 29 3b 0d 0a 20 20 65 |t.'..   | );..  e|
|00000210| 6e 64 20 69 66 3b 0d 0a | 00 1c 27                |nd if;..|..'     |
+--------+-------------------------+-------------------------+--------+--------+